# coding=UTF-8
#!/usr/bin/python3

import pandas as pd

#todayStr = str(date.today())
df = pd.read_excel('附件1：近期疫情重点关注地入滇驻留人员名单.xlsx' ,header=3, sheet_name = 'Sheet0')
print('读取附件1：近期疫情重点关注地入滇驻留人员名单.xlsx，前5行是这样：')
print(df.head())
ws_old = pd.read_excel('ws.xlsx' ,header=0, sheet_name = 'ws')
print('读取ws.xlsx，前5行是这样：')
print(ws_old.head())
newdf=df[~df.身份证号.isin(ws_old['身份证号'])]
print('删除重复的身份证号，前5行是这样：')
print(newdf.head())
newdf.to_excel('附件1：近期疫情重点关注地入滇驻留人员名单.xlsx' ,sheet_name = 'Sheet0',index=False)
print('已保存文件')
input()
